Tabela ExternalUserDefinition

Definicja tabeli ExternalUserDefinition

Name

ExternalUserDefinition

Code

ExternalUserDefinition

Comment

Definicja uzytkownika zewnetrznego systemu


Lista kolumn tabeli ExternalUserDefinition

Name

Code

ExternalUserDefinitionID

ExternalUserDefinitionID

SystemID

SystemID

PersonID

PersonID

ExternalOperatorTypeID

ExternalOperatorTypeID

Login

Login

Password

Password

StartDT

StartDT

StopDT

StopDT

Active

Active

DoctorIdentifier

DoctorIdentifier

NfzDepartmentID

NfzDepartmentID

IdntSwd

IdntSwd


Kolumna ExternalUserDefinitionID tabeli ExternalUserDefinition

Definicja kolumny ExternalUserDefinitionID tabeli ExternalUserDefinition

Name

ExternalUserDefinitionID

Code

ExternalUserDefinitionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna SystemID tabeli ExternalUserDefinition

Definicja kolumny SystemID tabeli ExternalUserDefinition

Name

SystemID

Code

SystemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Identyfikator zewnetrznego systemu, którego dotyczy uzytkownik


Kolumna PersonID tabeli ExternalUserDefinition

Definicja kolumny PersonID tabeli ExternalUserDefinition

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Identyfikator uzytkownika powiazanego z kontem do zewnetrznego systemu


Kolumna ExternalOperatorTypeID tabeli ExternalUserDefinition

Definicja kolumny ExternalOperatorTypeID tabeli ExternalUserDefinition

Name

ExternalOperatorTypeID

Code

ExternalOperatorTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator slownika typów operatora


Kolumna Login tabeli ExternalUserDefinition

Definicja kolumny Login tabeli ExternalUserDefinition

Name

Login

Code

Login

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Login do zewnetrznego systemu


Kolumna Password tabeli ExternalUserDefinition

Definicja kolumny Password tabeli ExternalUserDefinition

Name

Password

Code

Password

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Haslo do zewnetrznego systemu


Kolumna StartDT tabeli ExternalUserDefinition

Definicja kolumny StartDT tabeli ExternalUserDefinition

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli ExternalUserDefinition

Definicja kolumny StopDT tabeli ExternalUserDefinition

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Active tabeli ExternalUserDefinition

Definicja kolumny Active tabeli ExternalUserDefinition

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna DoctorIdentifier tabeli ExternalUserDefinition

Definicja kolumny DoctorIdentifier tabeli ExternalUserDefinition

Name

DoctorIdentifier

Code

DoctorIdentifier

Data Type

VARCHAR2(50)

Mandatory

No

Comment

Identyfikator lekarza uzywany przy logowaniu do systemu eWus zgodnie ze zgloszeniem 129005 i 129006


Kolumna NfzDepartmentID tabeli ExternalUserDefinition

Definicja kolumny NfzDepartmentID tabeli ExternalUserDefinition

Name

NfzDepartmentID

Code

NfzDepartmentID

Data Type

NUMBER(10)

Mandatory

No

Comment

kod swiadczeniodawcy


Kolumna IdntSwd tabeli ExternalUserDefinition

Definicja kolumny IdntSwd tabeli ExternalUserDefinition

Name

IdntSwd

Code

IdntSwd

Data Type

NUMBER(10)

Mandatory

No

Comment

od oddzialu NFZ


Lista kluczy tabeli ExternalUserDefinition

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ExternalUserDefinition

Definicja klucza Identifier_1 tabeli ExternalUserDefinition

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment